MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Object Name = 15094

View and edit SQL

Suggested facets: Title, Artist Role, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
334167 1976.67.24 0 0 481571 Modern and Contemporary Art 4 Salt shaker 15094 White Clover           Designer|Manufacturer 3   Russel Wright|Harker Pottery Company American, Lebanon, Ohio 1904–1976 New York|Chester, West Virginia   Wright, Russel|HARKER POTTERY 44953 American 1 1904 1976 1951 1951 1951 Porcelain 109 H. 3-3/4, W. 2 inches (9.5 x 5.1 cm.) Gift of Russel Wright, 1976                       Ceramics-Porcelain 307   Metropolitan Museum of Art, New York, NY 1
334200 1976.67.55 0 0 481604 Modern and Contemporary Art 4 Salt shaker 15094 Salt shaker           Designer 5   Russel Wright American, Lebanon, Ohio 1904–1976 New York   Wright, Russel 44926 American 1 1904 1976 ca. 1933 1928 1938 Silver 2 1 3/16 x 1 1/16 x 1 1/16 in. (3 x 2.7 x 2.7 cm) Gift of Russel Wright, 1976                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
334890 1981.435.22 0 0 482333 Modern and Contemporary Art 4 Salt shaker 15094 Salt shaker           Designer 5   Frederick Hurten Rhead American (born England), Hanley Stoke-on-Trent 1880–1942 New York   Rhead, Frederick Hurten 45233 American, born England 16 1880 1942 1930s 1930 1939 Glazed ceramic 14347 D. 2-3/8, H. 2-3/4 inches (6 x 7 cm.) Gift of Rev. and Mrs. Paul H. Hazlett, 1981                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
338042 1990.69.2 0 0 485649 Modern and Contemporary Art 4 Salt shaker 15094 "American Modern" Salt Shaker           Designer|Manufacturer 3   Russel Wright|Steubenville Pottery Company American, Lebanon, Ohio 1904–1976 New York|Steubenville, Ohio   Wright, Russel|STEUBENVILLE POTTERY COMPANY 44954 American|American 5 1904 1976 1937 1937 1937 Earthenware 21 H. 2, Diam. 1-7/8 inches (5.1 x 4.8 cm.) Gift of Laurence B. Kanter, 1990                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
338043 1990.69.3 0 0 485650 Modern and Contemporary Art 4 Salt shaker 15094 "American Modern" Salt Shaker           Manufacturer|Designer 18   Steubenville Pottery Company|Russel Wright Steubenville, Ohio|American, Lebanon, Ohio 1904–1976 New York   STEUBENVILLE POTTERY COMPANY|Wright, Russel 45978 American|American 5 1904 1976 designed 1937; produced from 1939 1937 1937 Earthenware 21 2 x Diam. 2 in. (5.1 x 5.1 cm) Gift of Laurence B. Kanter, 1990                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
341187 61.41.1 0 0 489157 Modern and Contemporary Art 4 Salt shaker 15094 Salt shaker           Designer|Manufacturer 3   Jens Quistgaard|Dansk International Designs Ltd. Danish, Copenhagen 1919–2008 Vordingborg   Quistgaard, Jens|DANSK INTERNATIONAL 45852 Danish 144 1919 2008 ca. 1960 1960 1960 Stainless steel 14439 H. 4-5/8, Diam. 1-1/4 inches (11.7 x 3.2 cm.) Gift of Dansk Designs, Inc., 1961                       Metalwork-Steel 329   Metropolitan Museum of Art, New York, NY 1
342142 2001.745.12 0 0 490773 Modern and Contemporary Art 4 Salt shaker 15094 "Town & Country" Salt Shaker           Designer|Manufacturer 3   Eva Zeisel|Red Wing Pottery American, Budapest 1906–2011 New City, New York|Red Wing, Minnesota   Zeisel, Eva|RED WING POTTERY 46242 American|American 5 1906 2011 1947 1947 1947 Glazed earthenware 9554 4 3/8 x 3 x 2 3/4 in. (11.1 x 7.6 x 7 cm) Gift of the artist, 2001                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 131.146ms · Data license: CC0 · Data source: metmuseum/openaccess